IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[subscriber]') AND TYPE in (N'U'))
BEGIN
CREATE Table subscriber
(
    subscriber_id INT IDENTITY(1,1) NOT NULL,
    name NVARCHAR(200) not NULL,
    email nvarchar(200) not null,
    telephone nvarchar(100) null,
    create_date DATETIME DEFAULT(GETDATE()),
    update_date DATETIME,
	CONSTRAINT PK_subscriber_id PRIMARY KEY CLUSTERED (subscriber_id)
) 
END
GO